SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
CREATE PROC [dbo].[usp_KiemTraChoTrong]
	@MATOUR CHAR(20),
	@SEAT INT OUT
AS
BEGIN 
	SET @SEAT = ( SELECT T.SO_CHO_CON_NHAN
	FROM TOUR T
	WHERE T.MA_TOUR = @MATOUR)
END

GO
